Mark Cronk
Mark Cronk
Reactions
-
Re: Multiple IF Formula for Matrix
Glad you found a solution. Thank you for contributing to the Community. Mark1 · -
Re: Multiple IF Formula for Matrix
Hi Lisa, Try: =IF (Influence@row = "High", 3, IF (Influence@row = "Medium", 2, IF (Influence@row = "Low", 1, IF (Influence@row = "None", 0)))) Your plan sounds…1 · -
Re: is there a way to sum a column of checkboxes?
Hi@David Park , You can count checked boxes. The formula is just =COUNT([box column]:[box column],=1) Insert the correct name for your checkbox column. To figure out % checked you need to count a col…2 · -
Re: Can I create a drop down list that is auto-populated based on values from a column on another sheet?
Hi @Alex Hackford , Unfortunately, you can't populate a drop down from another list. Dynamic dropdowns sounds like a great suggestion though. You can submit it as an enhancement idea using the link b…3 · -
Re: "#NO MATCH" Error for Vlookup with duplicate contacts
Hi @Luke Serrato , I'm not convinced this is a contact list issue. You're looking up text against text and not getting a match. Or, is your [Text Name] column actually populated with a formula? Is yo…1 ·
